2013-09-11 - 8481.700 - Spec - Assist with Crystal Report updates #CrystalReportsSupport

SPECIFICATIONS

8481.700 - Assist with Crystal Report updates

Requirement Summary


Need to point list of Crystal Reports below from BW 7.0 Query to BW 7.3 Query and need to create BEx queries in BW 7.3 development.

SNo
Folder
Report
1.
Accounts Receivable - Credit
AR100 - AR Statements
2.
Accounts Receivable - Credit
AR110 - AR Statement on Demand
3.
Accounts Receivable - Credit
AR120 - Credit Information for Control Area
4.
Accounts Receivable - Credit
AR220 - Accounts Receivable Aging Analysis by Sales Rep
5.
Accounts Receivable - Credit
AR250 - Accounts Receivable Aging Analysis By Sales Rep and Credit Rep
6.
Accounts Receivable - Credit
AR290 - AR Aging - Download
7.
Accounts Receivable - Credit
AR300 - Unapplied Report
8.
Accounts Receivable - Credit
AR310 - Canada Factoring Report
9.
Accounts Receivable - Credit
AR320 - Miami Factor Invoice
10.
Accounts Receivable - Credit
AUD100 - Audit for Customer Email
11.
Accounts Receivable - Credit
CA100 - Miami Factor Order Approval
12.
Accounts Receivable - Credit
CC100 - Credit Card Order Auth
13.
Accounts Receivable - Credit
CC110 - Credit Card Order Auth - on demand
14.
Accounts Receivable - Credit
CC120 - Payment Card Settlement
15.
Accounts Receivable - Credit
CC130 - Payment Card Settlement - on demand
16.
Accounts Receivable - Credit
CC140 - ZCC Payment Terms Settlement
17.
Accounts Receivable - Credit
CC150 - ZCC Payment Terms Settlement on demand
18.
Accounts Receivable - Credit
CC160 - Custom CC Orders On Demand
19.
Accounts Receivable - Credit
CC170 - Expired Credit Cards
20.
Accounts Receivable - Credit
CFO200 - EMEA Budget Analysis by Country
21.
Commissions and Royalties
COM100 - Commission Pay Report
22.
Commissions and Royalties
COM101 - Commission Pay Report (Item on Demand)
23.
Commissions and Royalties
COM120 - Unpaid Commission Report
24.
Commissions and Royalties
COM140 - Commission Reconciliation Report
25.
Commissions and Royalties
COM150 - Commission Accrued
26.
Commissions and Royalties
COM200 - Commission Condition 1
27.
Commissions and Royalties
COM210 - Commission Condition 2
28.
Commissions and Royalties
COM220 - Commission Condition 3
29.
Commissions and Royalties
COM230 - Commission Condition 4
30.
Commissions and Royalties
COM240 - Commission Condition 5
31.
Commissions and Royalties
ROY100 - Royalty Report v1
32.
Commissions and Royalties
ROY100 - Royalty Report v2
33.
Commissions and Royalties
ROY100 - Royalty Report v3
34.
Commissions and Royalties
ROY110 - Retail Royalty
35.
Commissions and Royalties
ROY200 - Royalty Condition 1
36.
Commissions and Royalties
ROY210 - Royalty Condition 2
37.
Commissions and Royalties
ROY220 - Royalty Condition 3
38.
Commissions and Royalties - Miami
COM105 - Commission Pay Report (Miami Export)
39.
Commissions and Royalties - Miami
COM106 - Commission Pay Report (Miami Printable)
40.
Commissions and Royalties - Miami
COM125 - Unpaid Commission Report (Miami Only)
41.
Commissions and Royalties - Miami
COM155 - Commission Accrued (Miami Only)
42.
Commissions and Royalties - Miami
ICO100 - Miami ICO AP Due List (with delivery)
43.
Commissions and Royalties - Miami
ICO110 - Miami ICO AP Due List (without delivery)
44.
Commissions and Royalties - Miami
ICO120 - Apparel Customer-ICO Invoice
45.
Corporate Dashboard - Source Reports
CD100 - Sales Analysis by Region, Sales Org, License and Team
46.
Corporate Dashboard - Source Reports
CD110 - Service Level by Region, Sales Org, License and Team
47.
Corporate Dashboard - Source Reports
CD120 - Product Detail by Region
48.
Corporate Dashboard - Source Reports
CD130 - Sales Analysis by Region, License and Team/Silhouette
49.
Financial Statements
FI100 - Consolidated Income Statement
50.
Financial Statements
FI110 - Income Statement
51.
Financial Statements
FI111 - Income Statement by Region
52.
Financial Statements
FI112 - Income Statement with Last Year
53.
Financial Statements
FI113 - Income Statement with Last Year Actuals Only
54.
Financial Statements
FI115 - Income Statement with Detail
55.
Financial Statements
FI120 - Income Statement in company currency
56.
Financial Statements
FI130 - Income Statement by SBU
57.
Financial Statements - Preliminary
FI100 - Consolidated Income Statement
58.
Financial Statements - Preliminary
FI110 - Income Statement
59.
Financial Statements - Preliminary
FI111 - Income Statement by Region
60.
Financial Statements - Preliminary
FI112 - Income Statement with Last Year
61.
Financial Statements - Preliminary
FI113 - Income Statement with Last Year Actuals Only
62.
Financial Statements - Preliminary
FI115 - Income Statement with Detail
63.
Financial Statements - Preliminary
FI120 - Income Statement in company currency
64.
Financial Statements - Preliminary
FI130 - Income Statement by SBU
65.
Human Resource
PAY100 - EMB_TAPE_QUERY
66.
Human Resource
PAY101 - EMB_RATE_CHECK
67.
Human Resource
PAY102 - DERBY_TRADE_PCT_HIST
68.
Human Resource
PAY103 - DERBY_TRADE_PERCENTAGES
69.
Human Resource
PAY104 - EMP_AVGS_BY_DEPARTMENT
70.
Human Resource
PAY105 - EMP_TRADE_HOURS
71.
Human Resource
PAY106 - EMP_W_TO_AND_EARNED
72.
Human Resource
PAY107 - RATE_SUMMARY_EXCEL
73.
Human Resource
PAY108 - TIME_OUT_ANALYSIS_EXCEL
74.
Human Resource
PAY109 - TIME_OUT_REPORT
75.
Human Resource
PAY110 - EMP_W_HRS_AND_NO_ENTRY
76.
Human Resource
PAY111 - EMB_TAPE_QUERY_STITCH_CNT
77.
Human Resource
PAY112 - Employee Rate Summary Report
78.
Human Resource
PAY113 - Daily Rate Report
79.
Human Resource
PAY114 - Daily Rate Report - Whole Week
80.
Human Resource
PAY115 - Emp Pay Detail Report
81.
Human Resource
PAY116 - Embroidery Tape Details
82.
Human Resource
PAY117 - Weekly Calc Data
83.
Human Resource
PAY118 - Weekly Rate Difference Report
84.
Human Resource
PAY119 - HR Weekly DOZENS
85.
Inventory
INV010 - Available to Promise Inventory by SBU and Season
86.
Inventory
INV015 - Available to Promise Inventory ROC Excluded
87.
Inventory
INV100 - ATP Inventory
88.
Inventory
INV200 - Residual Inventory by Team
89.
Inventory
INV300 – Stock Inventory Analysis
90.
Inventory
INV310 – Non-Replenished Inventory Analysis
91.
Inventory
INV320 - Base Cap Inventory
92.
Inventory
INV330 - Replenished Blank Apparel Inventory
93.
Inventory
INV340 - Base Apparel Inventory
94.
Inventory
INV350 - Consolidated Inventory Analysis
95.
Inventory
INV400 - EMEA Web Product Upload
96.
Inventory
INV500 - Inventory Report for NFL Upload
97.
Open Orders
DTC100 - NE by You Order Lookup
98.
Open Orders
DTC110 - NewErabyYou Exceptions
99.
Open Orders
DTC130 - New Era By You Reconciliation
100.
Open Orders
DTC120 - DTC Order Errors
101.
Open Orders
ICD100 - Open PO Report by ICD
102.
Open Orders
OSA100 - Open Orders by Date
103.
Open Orders
OSA110 – Open Orders by Country and Sales Rep
104.
Open Orders
OSA130 - Open Orders by Season, Collection, and Material
105.
Open Orders
OSA131 - Hot Market Open Orders by Collection, Team, and Material
106.
Open Orders
OSA132 – Open Orders by Season Collection Material by Month
107.
Open Orders
OSA170 - EDI-ROC ATP Exception Report
108.
Open Orders
OSA172 - Open Orders at risk of Cancel
109.
Open Orders
OSA175 - Open Orders by Sales Rep and Customer
110.
Open Orders
OSA180 - Open Orders by Plant
111.
Open Orders
OSA181 - Open Orders by Plant and Customer
112.
Open Orders
OSA185 - Open Orders for Retail
113.
Open Orders
OSA210 - Vendor Order Acknowledgement Report
114.
Open Orders
OSA350 - Open Orders for Hot Market
115.
Open Orders
OSA500 - Cancelled Orders by Year, Fiscal Period, Sales Rep and Customer
116.
Open Orders
OSA610 - AC Performance 30 Day Dating Program
117.
Open Orders
OSA900 - Open Orders by Sales Org, SBU, Sales Rep, Customer, Season and Collection
118.
Open Orders
OSA905 - Open Orders by Sales Org, SBU, Sales Rep, Customer, Season, Collection and Material
119.
Open Orders
OSA910 - Open Orders by Sales Org, SBU, Sport, License, Team and Style
120.
Open Orders
OSA915 - Open Orders by Sales Org, SBU, Sport, License, Team, Style and Material
121.
Open Orders
OSA920 - Open Order by by Sales Org, Sales Manager, Style, License, Sales Rep and Account
122.
Open Orders
PTO100 - PTO Monitoring On Demand
123.
Open Orders
ROC100 - ROC Order Errors
124.
Partner Compliance
PNC100 - Chargeback in pending status over 5 days
125.
Partner Compliance
PNC110 - Dismissed Vendor Document Chargebacks
126.
Partner Compliance
PNC130 - Chargebacks Initiated yet Invoiced
127.
Partner Compliance
PNC140 - Dismissed Chargebacks
128.
Partner Compliance
PNC150 - Receiving CB Pending Over 5 Days
129.
Partner Compliance
PNC160 - Receiving Initiated yet Invoiced
130.
Partner Compliance
PNC170 - Receiving Compliance Not Pending or Dismissed
131.
Partner Compliance
PNC180 - Dismissed Receiving Compliance Chargebacks
132.
Partner Compliance
PNC190 - Partially Dismissed Receiving Chargebacks
133.
Partner Compliance
PNC200 - Receiving Compliance Invoiced Chargebacks
134.
Planning
ARUN100 - United Kingdom ARUN Log File Information by CSR
135.
Planning
ARUN110 - North America ARUN Log File Information by CSR
136.
Planning
MD06 Miami and DR by Order
137.
Planning
OPP100 - Apparel MRP Detail
138.
Planning
OPP200 - MRP Exception Messages
139.
Planning
OPP300 - Open Orders for Forcasting
140.
Planning
OPP400 - UK Partsheet
141.
Planning
OPP410 - UK Partsheet by Season
142.
Planning
OPP500 - MRP Vendor Exception Message
143.
Planning
OPP600 - Stock Demand Analysis
144.
Planning
OPP700 - Released Production Orders by Style, Fabric and Grid Value
145.
Procurement
PRO100 - Purchase Order Missing Pricing Condition Exceptions
146.
Procurement
PRO110 - Info Record Exception
147.
Procurement
PRO120- Raw Material FCC & PMS
148.
Procurement
PRO130 - Open Purchase Requisition By Customer
149.
Procurement
PRO140 - Basic_SO_UPC
150.
Procurement
PRO150 - ROAL Materials by Fabric
151.
Procurement
PRO160 - SPS Catalog Upload
152.
ReCAP
RCP100 - Daily Change Management ReCAP
153.
ReCAP
RCP110 - ReCAP Splash History
154.
ReCAP
RCP120 - ReCAP - Unresolved Change Management
155.
ReCAP
RCP130 - ReCAP - Change Management detail by project
156.
ReCAP
RCP140 - ReCAP - Implemented change management during a date range
157.
ReCAP
RCP200 - IT Department Weekly ReCAP
158.
ReCAP
RCP210 - Weekly ReCAP with Subprojects
159.
ReCAP
RCP220 - Weekly ReCAP by Business Area and Department
160.
ReCAP
RCP230 - ReCAP Status History Query by Project Number
161.
ReCAP
RCP240 - ReCAP Project Query by Ticket Owner
162.
ReCAP
RCP250 - VISION 2015
163.
ReCAP
RCP255 - VISION 2016
164.
ReCAP
RCP260 - IT Status Report - Executive
165.
ReCAP
RCP270 - BMS Weekly ReCAP
166.
ReCAP
RCP280 -BMS Weekly ReCAP with Subprojects
167.
ReCAP
RCP300 - Weekly ReCAP with Subprojects
168.
ROC and ROAL
ROA100 - ROAL Spec
169.
ROC and ROAL
ROA110 - ROAL Spec Chinese
170.
ROC and ROAL
ROA200 - Custom Catalog
171.
ROC and ROAL - Sell Sheets
ECAT100 Order Form
172.
ROC and ROAL - Sell Sheets
ROAL SPEC 2.0
173.
ROC and ROAL - Sell Sheets
ROAL SPEC 2.0Prod
174.
ROC and ROAL - Sell Sheets
ROAL SPEC 2.0qa
175.
ROC and ROAL - Sell Sheets
ROC200 - One Cap Sell Sheet
176.
ROC and ROAL - Sell Sheets
ROC210 - Three Cap Sell Sheet
177.
ROC and ROAL - Sell Sheets
ROC220 - Six Cap Sell Sheet
178.
ROC and ROAL - Sell Sheets
ROC230 - Nine Cap Sell Sheet
179.
ROC and ROAL - Sell Sheets
ROC240 - Sixteen Cap Sell Sheet
180.
Sales Analysis
SA110 - Corporate Scorecard
181.
Sales Analysis
SA115 - Corporate Scorecard By Regions
182.
Sales Analysis
SA120 - Customer Scorecard
183.
Sales Analysis
SA130 - Miami Scorecard
184.
Sales Analysis
SA 140 - License Scorecard
185.
Sales Analysis
SA150 - Sales % to Goal
186.
Sales Analysis
SA160 - Shipped + Open by Sales Rep and Customer
187.
Sales Analysis
SA170 - Shipped + Open by Region and Country
188.
Sales Analysis
SA175 - Sales Analysis by Region and Country
189.
Sales Analysis
SA200 - Sales Analysis by Sales Org, SBU and Customer
190.
Sales Analysis
SA210 - Sales Analysis by Sales Org and Customer
191.
Sales Analysis
SA215 - Sales Analysis By Sales Org, Customer Group and Customer
192.
Sales Analysis
SA220 - Sales Analysis by Sales Org, Country and Customer
193.
Sales Analysis
SA230 - Sales Analysis by Sales Org, License and Team
194.
Sales Analysis
SA231 - MLB Sales Analysis by Material Group and Region
195.
Sales Analysis
SA240 - Sales Analysis by Sales Org, Silhouette and Collection
196.
Sales Analysis
SA270 - Sales Analysis by Sales Org,Sales Rep and Customer
197.
Sales Analysis
SA275 - Sales Analysis By Sales Org, Country, Sales Rep and Customer
198.
Sales Analysis
SA300 - Sales Analysis By Region, License and Sales Org
199.
Sales Analysis
SA350 - Sales Analysis for Hot Market
200.
Sales Analysis
SA900 - Sales Analysis by Sales Org, SBU, Sales Rep, Customer, Season and Collection
201.
Sales Analysis
SA905 - Sales Analysis by Sales Org, SBU, Sales Rep, Customer, Season, Collection and Material
202.
Sales Analysis
SA910 - Sales Analysis by Sales Org, SBU, Sport, License, Team and Style
203.
Sales Analysis
SA915 - Sales Analysis by Sales Org, SBU, Sport, License, Team, Style and Material
204.
Sales Analysis
SA920 - Sales Analysis by Sales Org, Sales Manager, Style, License, Sales Rep and Account
205.
Sales Analysis
SAS270 - Sales Analysis by Sales Rep
206.
Service Level
SL100 - Sales Order Service Level by Sales Org, Customer, and Order Type
207.
Service Level
SL110 - Sales Order Service Level by Sales Org, Plant, and Season
208.
Service Level
SL130 - Service Level by Sales Org, License and Team
209.
Service Level
SL140 - Service Level by Sales Org, Season and Collection
210.
Shipped Orders
SH100 - Shipped Orders by Sales Rep and Customer
211.
Shipped Orders
SH250 - Hot Market Cap Machine And Heat Seal
212.
Shipped Orders
SH251 - Hot Market Shipped Report
213.
Shipped Orders
SH300 - EMEA Web Units by Product Group
214.
Taxes and Pricing
PRI100 - Customer Discount Levels
215.
Taxes and Pricing
PRI200 Net Price Report On Demand
216.
Taxes and Pricing
PRI300 - Last PO Price to Standard Cost Variance
217.
Taxes and Pricing
PRI400 - Material Last List Price
218.
Taxes and Pricing
TAX100 - Sales and Use Tax
219.
Taxes and Pricing
TAX115 - US Tax Report (Jan-May)
220.
Taxes and Pricing
TAX115 - US Tax Report (Jun-Dec)
221.
Taxes and Pricing
TAX125 - Tax Jurisdiction Report
222.
Taxes and Pricing
TAX126 - Tax Jurisdiction Listing
223
Taxes and Pricing
TAX200 - Sales and COGS Manufactured Non US
224.
Taxes and Pricing
TAX210 - Sales and COGS Manufactured US
225.
Taxes and Pricing
TAX220 - Sales and COGS Manufactured Stock Non US
226.
Taxes and Pricing
TAX230 - Sales and COGS Manufactured Stock US
227.
Taxes and Pricing
TAX240 - SD Billings Without Tax Codes
228.
Warehouse
WMS300 - Distribution Center Metrics
229.
Warehouse
WMS310 - Menlo Missing Materials
230.
Warehouse
WMS330 - Delivery Aging Action Items
231.
Warehouse
WMS331 - Delivery Aging Action Items Download
232.
Warehouse
WMS340 - Delivery Aging Info Items
233.
Warehouse
WMS400 - C.O.D Deliveries
234.
Warehouse
WMS410 - Open Deliveries
235.
Warehouse
WMS420 - End of Day Shipping Report
236.
Warehouse
WMS425 - PO SO Report
237.
Warehouse
WMS430 - Shipping Units Based on Deliveries
238.
Warehouse
WMS500 - VAS Exception Report
239.
Warehouse
WMS501 - VAS Exception Report
240.
Warehouse
WMS510 - VAS Codes - ALL
241.
Warehouse
WMS520 - VAS Codes by Customer
242.
Warehouse
WMS530 - VAS Codes by Customer with Drilldown
243.
Warehouse
WMS540 - UOM Exception Report
244.
Warehouse
WMS600 - GSCI Exceptions
245.
Warehouse
WMS610 - GSCI Purchase Orders
246.
Warehouse
WMS620 - UPS Deliveries Exception Report
247.
Warehouse
WMS630 - GSCI Packing Instructions
248.
Warehouse
WMS640 - GSCI Purchase Order Payment Dates
249.
Warehouse
WMS650 - GSCI Packing Details
250.
Warehouse
WMS700 - 3rd Party Carrier Exceptions
251.
Warehouse
WMS710 - Routing Report
252.
Warehouse
WMS720 - Requested Routing Exceptions
253.
Warehouse - APAC
WMS200 - NEC Menlo Inventory Exceptions
254.
Warehouse - DSCO
DSCO100 - Embroidery
255.
Warehouse - DSCO
DSCO110 - Embroidery Chinese
256.
Warehouse - DSCO
DSCO120 - Component
257.
Warehouse - DSCO
DSCO130 - Component Chinese
258.
Warehouse - DSCO
DSCO400 - Carrier Shipments
259.
Warehouse - DSCO
DSCO405 - Carrier Shipments Fedex
260.
Warehouse - DSCO
DSCO410 - Order Information
261.
Warehouse - DSCO
DSCO420 - VAS Information
262.
Warehouse - DSCO
DSCO430 - PO Report
263.
Warehouse - EMEA
WMS200 - NEC Menlo Inventory Exceptions
264.
Warehouse - EMEA
WMS210 - NEC Menlo Delivery Exceptions
265.
Warehouse - EMEA
WMS215 - NEC Menlo Delivery Exceptions History
266.
Warehouse - EMEA
WMS217 - NEC Menlo Return Exceptions
267.
Warehouse - EMEA
WMS220 - NEC Menlo PO STO Exceptions
268.
Warehouse - EMEA
WMS230 - NEC Menlo Inventory Adjustment Exceptions
269.
Warehouse - EMEA
WMS240 - NEC Menlo Status Change Exceptions
270.
Warehouse - EMEA
WMS250 - NEC Menlo Open Delivery Exceptions
271.
Warehouse - EMEA
WMS255 - NEC Menlo Open Return Exceptions
272.
Warehouse - EMEA
WMS260 - NEC Menlo Open PO STO Exceptions
273.
Warehouse - Mexico
WMS200 - NEC Menlo Inventory Exceptions
274.
Warehouse - North America
WMS200 - NEC Menlo Inventory Exceptions
275.
Warehouse - North America
WMS205 - NEC Menlo Inventory Exceptions
276.
Warehouse - North America
WMS210 - NEC Menlo Delivery Exceptions
277.
Warehouse - North America
WMS215 - NEC Menlo Delivery Exceptions History
278.
Warehouse - North America
WMS217 - NEC Menlo Return Exceptions
279.
Warehouse - North America
WMS220 - NEC Menlo PO STO Exceptions
280.
Warehouse - North America
WMS230 - NEC Menlo Inventory Adjustment Exceptions
290.
Warehouse - North America
WMS240 - NEC Menlo Status Change Exceptions
291.
Warehouse - North America
WMS250 - NEC Menlo Open Delivery Exceptions
292.
Warehouse - North America
WMS255 - NEC Menlo Open Return Exceptions
293.
Warehouse - North America
WMS260 - NEC Menlo Open PO STO Exceptions
294.
Datasource Reports - Scorecard
OpenOrdersSubReportScorecard
295.
Datasource Reports - Scorecard
ScorecardDataByCountry
296.
Datasource Reports - Scorecard
ScorecardDataByRegion
297.
Datasource Reports - Scorecard
ScorecardRetailData
298.
Datasource Reports - Scorecard
ScorecardSapBudgetData
299.
Datasource Reports - Scorecard
ScorecardSAPData
300.
Data Soucre Reports
OSA - Open Order for % to Goal.rpt
301.
Data Soucre Reports
OSA800 - Customer Open Orders
302.
Data Soucre Reports
Repository Functions
303.
Data Soucre Reports
SA - by Sales Rep for % to Goal.rpt
304.
Data Soucre Reports - Dashboard
SL110 - Sales Order Service Level by Sales Org and Plant
305.
Data Soucre Reports - Finance
FI210 - Income Statement
306.
Data Soucre Reports - Finance
FI213 - Income Statement with Last Year Actuals Only
307.
Data Soucre Reports - Inventory
INV140 - Available Titleist Inventory
308.
Data Soucre Reports - Inventory
NFLopenorders
309.
Data Soucre Reports - ROC
605_1000_INVENTORYEXTRACT
310.
Data Soucre Reports - ROC
605_1200_INVENTORYEXTRACT
311.
Data Soucre Reports - ROC
605_2000_INVENTORYEXTRACT
312.
Data Soucre Reports - ROC
607_1000_INVENTORYEXTRACT
313.
Data Soucre Reports - ROC
607_1200_INVENTORYEXTRACT
314.
Data Soucre Reports - ROC
607_2000_INVENTORYEXTRACT
315.
Data Soucre Reports - ROC
608_1000_INVENTORYEXTRACT
316.
Data Soucre Reports - ROC
608_1200_INVENTORYEXTRACT
317.
Data Soucre Reports - ROC
608_2000_INVENTORYEXTRACT
318.
Data Soucre Reports - ROC
Chase_1000_INVENTORYEXTRACT
319.
Data Soucre Reports - ROC
Chase_1200_INVENTORYEXTRACT
320.
Data Soucre Reports - ROC
Chase_2000_INVENTORYEXTRACT
321.
Data Soucre Reports - ROC
RES_1000_INVENTORYEXTRACT
322.
Data Soucre Reports - ROC
RES_1200_INVENTORYEXTRACT
323.
Data Soucre Reports - ROC
RES_2000_INVENTORYEXTRACT
324.
Data Soucre Reports - ROC
STS_1000_INVENTORYEXTRACT
325.
Data Soucre Reports - ROC
STS_1200_INVENTORYEXTRACT
326.
Data Soucre Reports - ROC
STS_2000_INVENTORYEXTRACT
327.
Enterprise Performance Mgmt
EPM100 - Income Statement Summary
328.
Enterprise Performance Mgmt
EPM110 - Income Statement Details
329.
Enterprise Performance Mgmt
EPM199 - Region Scorecard
330.
Enterprise Performance Mgmt
EPM200 - Customer Scorecard
331.
Enterprise Performance Mgmt
EPM210 - Customer Segment Scorecard
332.
Enterprise Performance Mgmt
EPM220 - License Scorecard
333.
Enterprise Performance Mgmt
EPM230 - Product Mix Scorecard
334.
Enterprise Performance Mgmt
EPM240 - Sillhouette Scorecard
335.
Enterprise Performance Mgmt - EMEA
EPM203 - Customer Scorecard - EMEA
336.
Enterprise Performance Mgmt - EMEA
EPM213 - Customer Segment Scorecard - EMEA
337.
Enterprise Performance Mgmt - EMEA
EPM223 - License Scorecard - EMEA
338.
Enterprise Performance Mgmt - EMEA
EPM233 - Product Mix Scorecard - EMEA
339.
Enterprise Performance Mgmt - EMEA
EPM243 - Silhouette Scorecard - EMEA
340.
Enterprise Performance Mgmt - Emerging Markets
EPM202 - Customer Scorecard - Emerging Markets
341.
Enterprise Performance Mgmt - Emerging Markets
EPM212 - Customer Segment Scorecard - Emerging Markets
342.
Enterprise Performance Mgmt - Emerging Markets
EPM222 - License Scorecard - Emerging Markets
343.
Enterprise Performance Mgmt - Emerging Markets
EPM232 - Product Mix Scorecard - Emerging Markets
344.
Enterprise Performance Mgmt - Emerging Markets
EPM242 - Sillhouette Scorecard - Emerging Markets
345.
Enterprise Performance Mgmt - North America
EPM201 - Customer Scorecard - North America
346.
Enterprise Performance Mgmt - North America
EPM211 - Customer Segment Scorecard - North America
347.
Enterprise Performance Mgmt - North America
EPM221 - License Scorecard - North America
348.
Enterprise Performance Mgmt - North America
EPM231 - Product Mix Scorecard - North America
349.
Enterprise Performance Mgmt - North America
EPM241 - Sillhouette Scorecard - North America

Admin Info


Purpose
Need to update Crystal reports from 7.0 to 7.3 for sales analysis, open orders and service levels
Requested By
Jack Mehltretter
Spec Created By
Praveen Guntuka
Spec Created Date
09/11/2013
Spec QA by
Uday Kumar P
Objects
None
Document Status
Complete

References


Prior Tickets

8481.600

Documents

None

Functional Requirement


1. Need to update above list of Crystal Reports from BW 7.0 Production queries to BW 7.3 Development/Quality/Production queries.
2. Need to fix the issues and schedule the reports in BOBI 4.0 Development server
3. Need to create BEx queries in BW 7.3 development system.

Solution Summary


1. Need to import the Crystal Reports from BI Launchpad Production server's respective folders.
2. Need to update the reports from BW 7.0 production query to BW 7.3 Development queries.
3. Need to map the old fields to new query fields.
4. Need to run the report in the Crystal Report designer.
5. Need to export the report to BI Launchpad Development server.
6. Need to schedule the reports in BI Launchpad Development server.

Test Plan

SNo.
Test Scenario
Expected Results
1.
Report Format
As per NEC standards
2.
Execute Crystal Report in Crystal Designer tool after changes
Report should execute successfully in Crystal Designer tool
3.
Scheduling the Report in NEC BI Launch Pad
Report should execute successfully in NEC BI Launch Pad

Solution Details


1. Need to import the Crystal Reports from BI Launchpad Production server's respective folders.
2. Need to update the reports from BW 7.0 production query to BW 7.3 Development queries.
3. Need to map the old fields to new query fields.
4. Need to run the report in the Crystal Report designer.
5. Need to export the report to BI Launchpad Development server.
6. Need to schedule the reports in BI Launchpad Development server.
7. Need to create BEx queries in the BPD source.
8. Need to point the created queries to respective Crystal reprots.

Issues


None